﻿
CREATE VIEW [dbo].[onco_viewSchemaInternare]
AS
SELECT     dbo.onco_SchemaInternare.Ziua, dbo.onco_SchemaInternare.ZiuaCiclu2, dbo.onco_Citostatice.Denumire, dbo.onco_SchemaInternare.Doza, 
                      dbo.onco_SchemaInternare.Explicatie, dbo.onco_SchemaInternare.IDInternare, dbo.onco_SchemaInternare.DozaRecomandata, 
                      dbo.onco_SchemaInternare.DozaPrescrisa, dbo.onco_SchemaInternare.UM, DATEADD(day, dbo.onco_SchemaInternare.Ziua, dbo.Internare.OncoDataStartChimioTer) 
                      AS OncoDataStartChimioTer, dbo.onco_SchemaInternare.IDSchema
FROM         dbo.onco_SchemaInternare INNER JOIN
                      dbo.onco_Citostatice ON dbo.onco_SchemaInternare.IDCitostatic = dbo.onco_Citostatice.IDCitostatic INNER JOIN
                      dbo.Internare ON dbo.onco_SchemaInternare.IDInternare = dbo.Internare.IDInternare